Data Review

head(RepairData)
##                  CreatedDate YearMonth UnitNumber      VMRS JobType UnitType
## 1 2015-01-02 00:00:00.000   2015-01     08I005     13-61       L      08I
## 2    2015-01-02 00:00:00.000   2015-01     08I005     13-61       L      08I
## 3    2015-01-02 00:00:00.000   2015-01     08I005     07-61       L      08I
## 4    2015-01-02 00:00:00.000   2015-01     08I005     07-61       L      08I
## 5    2015-01-02 00:00:00.000   2015-01     08I005 70-61-000       L      08I
## 6    2015-01-02 00:00:00.000   2015-01     08I005 70-61-000       L      08I
##   Vendor                                    RepairNotes Ext_Cost Parts_Cost
## 1   NULL                REPAIR/MODIF BOOM & COMPONENTS         0          0
## 2   NULL                REPAIR/MODIF BOOM & COMPONENTS         0          0
## 3   NULL                   LUBRICATE BOOM & COMPONENTS         0          0
## 4   NULL                   LUBRICATE BOOM & COMPONENTS         0          0
## 5   NULL PERFORM BOOM & COMPONENTS PIKE BOOM INSPECTION        0          0
## 6   NULL PERFORM BOOM & COMPONENTS PIKE BOOM INSPECTION        0          0
##   Labor_Hours     DateMY
## 1        2.72 2015-01-01
## 2        0.00 2015-01-01
## 3        1.12 2015-01-01
## 4        0.00 2015-01-01
## 5        3.27 2015-01-01
## 6        0.00 2015-01-01

The data elements in this set are:

Vendor Details

Seeing the increase in Extended Cost, lets dig into the top 20 vendors from 2018 to 2020 to see the delta over the past few years.

## # A tibble: 20 x 2
##    Vendor                                 ExtCost
##    <chr>                                    <dbl>
##  1 ALTEC INDUSTRIES INC.                31322943.
##  2 REPAIR CENTRAL LLC                   22621281.
##  3 BRIDGESTONE AMERICAS TIRE OPERATIONS  8521351.
##  4 MISCELLANEOUS VENDOR                  6772268.
##  5 FORD QUALITY FLEET CARE               2806376.
##  6 GMFLEETTRAC PROCESSING CENTER         2744641.
##  7 RUSH TRUCK CENTERS OF TEXAS           2469541.
##  8 SOUTHERN TIRE MART LLC                2396538.
##  9 FLEET CHARGE                          1164497.
## 10 JAMES RIVER EQUIPMENT-CHARLOTTE       1115563.
## 11 GOODYEAR TIRE & RUBBER CO              803480.
## 12 NAPA 01709                             783636.
## 13 TSE INTERNATIONAL INC                  708575.
## 14 KENWOOD USA CORP COMM-LAND MOB         673399.
## 15 SAFELITE GLASS CORP                    636720.
## 16 JIFFY LUBE 2738 WAKE FOREST NC         626094.
## 17 GLOBAL RENTAL CO INC                   624192.
## 18 VERMEER SOUTHEAST SALES                585779.
## 19 TEREX GLOBAL GMBH                      575038.
## 20 RECHTIEN INTERNATIONAL-FLEET           561723.

Now, we can take a look at the trends that each of the top 20 vendors went through over the past 3 years.

The chart highlights the growth of Altec and Repair Central in comparison to all other vendors. The second chart is a cleaner look with all other vendors lumped into All Others. But when we look at all vendors, we can see there is a general growth from all major external vendors over the past 3 years.